<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>家具列表</title>
</head>
<body>
<?php
  require_once('../system/myFunc.php');
  require_once('../system/dbConn.php'); 
  connect();

  $id = $_GET['id'];
  $sql="select * from jiaju where sqh_id =$id";
  $result=fetch_array($sql);
?>
<table align="center" width="80%" border="1">
<center><h3>家具详细信息</h3></center>
<tr>
    <th>家具名称</th>
	
	<th>家具类别</th>

	<th>家具品牌</th>

	<th>家具添加时间</th>

	<th>家具图片</th>

	<th>家具简介</th>
</tr>	


<?php
  foreach ($result as $row) {
	 echo '<tr>';
   
	echo "<td><a href='detail.php?id=".$row['sqh_id']."'>".$row['sqh_name']."</a></td>";

     //echo '<td>'.$row['sqh_cname'].'</td>';

     echo '<td>'.$row['sqh_brand'].'</td>';

     echo '<td>'.$row['sqh_adddate'].'</td>';

	 echo '<td><img src="../upload/'.$row['sqh_jiajulink'].'" width="80px"  height="80px" class="img-rounded"></td>'; 
	 
	 
	 echo '<td>'.$row['sqh_intro'].'</td>';
	 	 
	
   echo '<td><a href="">修改</a> |
   <a href="fDelete.php?id='.$row['sqh_id'].' " onClick="return confirm(\'确定要删除吗？\');">删除</a></td>';

	 echo '</tr>';  
  }
  echo '</table>';  
  $totalrows = count($result);
  echo "<table align='center'><tr><td>共有{$totalrows}鲜花数</td></tr></table>";   
 ?>
</table>
</body>
</html>
